This Analysis Model is used for: Procurement. There is a list of Analysis Models pre-packaged and delivered as a part of Analysis Models - Power BI, and you can refer to them here.
Main analysis scenarios are:
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| CURRENCY RATES | FACT_CURRENCY_RATES_PQ_BI | FACT_CURRENCY_RATES_PQ | On Line |
| PURCHASE ORDER CHARGE | FACT_PURCHASE_ORD_CHARGE_PQ_BI | FACT_PURCHASE_ORD_CHARGE_PQ | On Line |
| PURCHASE ORDER LINE | FACT_PURCHASE_ORD_LINE_PQ_BI | FACT_PURCHASE_ORD_LINE_PQ | On Line |
| SPEND ANALYSIS | FACT_SPEND_ANALYSIS_PQ_BI | FACT_SPEND_ANALYSIS_PQ | On Line |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
FACT_PURCHASE_ORDER_LINE
Purchase Order Line information source is based on IFS\Purchase Orders. This
information source can be used to design reports and queries about suppliers and
purchase order lines. Main focus is on purchase amounts and delivery
performance.
FACT_PURCHASE_ORDER_CHARGE
Purchase Order Line information source is based on IFS\Purchase Charges. This
information source can be used to design reports and queries about charges
connected to purchase orders.
FACT_SPEND ANALYSIS
Spend Analysis information source is based on IFS\Spend Analysis. This
information source can be used to design reports and queries about spend amounts based on purchase orders, supplier invoices and maverick spend.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| CREATED DATE | |||
| WANTED DELIVERY DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ACTIVITY | DIM_ACTIVITY_BI | DIM_ACTIVITY | On Line |
| SALES REPRESENTATIVE | DIM_BUSINESS_REP_BI | DIM_BUSINESS_REP | On Line |
| CODE B | DIM_CODE_B_BI | DIM_CODE_B | On Line |
| CODE C | DIM_CODE_C_BI | DIM_CODE_C | On Line |
| CODE D | DIM_CODE_D_BI | DIM_CODE_D | On Line |
| CODE F | DIM_CODE_F_BI | DIM_CODE_F | On Line |
| CODE E | DIM_CODE_E_BI | DIM_CODE_E | On Line |
| CODE G | DIM_CODE_G_BI | DIM_CODE_G | On Line |
| CODE I | DIM_CODE_I_BI | DIM_CODE_I | On Line |
| COMPANY | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| CODE J | DIM_CODE_J_BI | DIM_CODE_J | On Line |
| ACCOUNT | DIM_ACCOUNT_BI | DIM_ACCOUNT | On Line |
| EXTERNAL SERVICE TYPE | DIM_EXTERNAL_SERVICE_TYPE_BI | DIM_EXTERNAL_SERVICE_TYPE | On Line |
| FORWARDER | DIM_FORWARDER_BI | DIM_FORWARDER | On Line |
| INSPECTION CODE | DIM_INSPECTION_CODE_BI | DIM_INSPECTION_CODE | On Line |
| CAT ASSORTMENT | DIM_PROC_CAT_ASSORTMENT_BI | DIM_PROC_CAT_ASSORTMENT | On Line |
| CAT ASSORTMENT NODE | DIM_PROC_CAT_ASSORTMNT_NODE_BI | DIM_PROC_CAT_ASSORTMNT_NODE | On Line |
| CODE H | DIM_CODE_H_BI | DIM_CODE_H | On Line |
| INTERNAL DESTINATION | DIM_INTERNAL_DESTINATION_BI | DIM_INTERNAL_DESTINATION | On Line |
| INVENTORY LOCATION | DIM_INVENTORY_LOCATION_BI | DIM_INVENTORY_LOCATION | On Line |
| INVENTORY PART | DIM_INVENTORY_PART_PQ_BI | DIM_INVENTORY_PART_PQ | On Line |
| ORDER CANCEL REASON | DIM_ORDER_CANCEL_REASON_BI | DIM_ORDER_CANCEL_REASON | On Line |
| ORDER COORDINATOR | DIM_ORDER_COORDINATOR_BI | DIM_ORDER_COORDINATOR | On Line |
| ORDER DELIVERY TERM | DIM_ORDER_DELIVERY_TERM_BI | DIM_ORDER_DELIVERY_TERM | On Line |
| PROJECT | DIM_PROJECT_BI | DIM_PROJECT | On Line |
| PURCHASE BUYER | DIM_PURCHASE_BUYER_BI | DIM_PURCHASE_BUYER | On Line |
| PURCHASE CHARGE TYPE | DIM_PURCHASE_CHARGE_TYPE_BI | DIM_PURCHASE_CHARGE_TYPE | On Line |
| PURCHASE GROUP | DIM_PURCHASE_GROUP_BI | DIM_PURCHASE_GROUP | On Line |
| QUALITY CONTROL ANALYST | DIM_QUALITY_CTRL_ANALYST_BI | DIM_QUALITY_CTRL_ANALYST | On Line |
| REPORTING CURRENCY | DIM_REPORTING_CURRENCY_PQ_BI | DIM_REPORTING_CURRENCY_PQ | On Line |
| REPORTING DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| REPORTING PERIOD | DIM_REPORTING_PERIOD_PQ_BI | DIM_REPORTING_PERIOD_PQ | On Line |
| REQUISITIONER | DIM_REQUISITIONER_BI | DIM_REQUISITIONER | On Line |
| SHIP VIA | DIM_MPCCOM_SHIP_VIA_BI | DIM_MPCCOM_SHIP_VIA | On Line |
| SITE | DIM_SITE_BI | DIM_SITE | On Line |
| SUB PROJECT | DIM_SUB_PROJECT_PQ_BI | DIM_SUB_PROJECT_PQ | On Line |
| SUPPLIER | DIM_SUPPLIER_BI | DIM_SUPPLIER | On Line |
| SUPPLIER ASSORTMENT | DIM_SUPPLIER_ASSORTMENT_BI | DIM_SUPPLIER_ASSORTMENT | On Line |
| SUPPLIER STAT GROUP | DIM_SUPPLIER_STAT_GROUP_BI | DIM_SUPPLIER_STAT_GROUP | On Line |
| TECHNICAL COORDINATOR | DIM_TECHNICAL_COORDINATOR_BI | DIM_TECHNICAL_COORDINATOR | On Line |
| CONDITION CODE | DIM_CONDITION_CODE_BI | DIM_CONDITION_CODE | On Line |
| ISO UNIT | DIM_ISO_UNIT_PQ_BI | DIM_ISO_UNIT_PQ | On Line |
| PURCHASE PART | DIM_PURCHASE_PART_PQ_BI | DIM_PURCHASE_PART_PQ | On Line |
The Procurement model supports calculation of base currency amounts to a reporting currency. To make this work it is necessary to create/select a currency rate type in one company as the rate source. The relevant configuration lookup must also be defined.
Please refer to Technical Documentation for more information.
The Procurement model is using the Company Reporting Period dimension, which means that it is necessary to create a specific Reporting Period Definition to be used by this cube. The created/selected identity must also be defined in the lookup configuration for the Tabular Model, using Source = 'Procurement'.
Please refer technical documentation for more information.
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID) |
| CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID) |
| PURCHASE ORDER CHARGE (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| PURCHASE ORDER CHARGE (DIM_CHARGE_TYPE_ID) - PURCHASE CHARGE TYPE (ID) |
| PURCHASE ORDER CHARGE (DIM_COMPANY_ID) - COMPANY (ID) |
| PURCHASE ORDER CHARGE (DIM_PO_ORDER_DATE_ID) - CREATED DATE (ID) |
| PURCHASE ORDER CHARGE (DIM_PROJECT_ID) - PROJECT (ID) |
| PURCHASE ORDER CHARGE (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |
| PURCHASE ORDER CHARGE (DIM_REPORTING_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| PURCHASE ORDER CHARGE (DIM_SITE_ID) - SITE (ID) |
| PURCHASE ORDER CHARGE (DIM_SUB_PROJECT_ID) - SUB PROJECT (ID) |
| PURCHASE ORDER LINE (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| PURCHASE ORDER LINE (DIM_COMPANY_ID) - COMPANY (ID) |
| PURCHASE ORDER LINE (DIM_CONDITION_CODE_ID) - CONDITION CODE (ID) |
| PURCHASE ORDER LINE (DIM_EXTERNAL_SERVICE_TYPE_ID) - EXTERNAL SERVICE TYPE (ID) |
| PURCHASE ORDER LINE (DIM_FORWARDER_ID) - FORWARDER (ID) |
| PURCHASE ORDER LINE (DIM_INSPECTION_CODE_ID) - INSPECTION CODE (ID) |
| PURCHASE ORDER LINE (DIM_INTERNAL_DESTINATION_ID) - INTERNAL DESTINATION (ID) |
| PURCHASE ORDER LINE (DIM_INVENTORY_LOCATION_ID) - INVENTORY LOCATION (ID) |
| PURCHASE ORDER LINE (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| PURCHASE ORDER LINE (DIM_MPCCOM_SHIP_VIA_ID) - SHIP VIA (ID) |
| PURCHASE ORDER LINE (DIM_ORDER_CANCEL_REASON_ID) - ORDER CANCEL REASON (ID) |
| PURCHASE ORDER LINE (DIM_ORDER_COORDINATOR_ID) - ORDER COORDINATOR (ID) |
| PURCHASE ORDER LINE (DIM_ORDER_DELIVERY_TERM_ID) - ORDER DELIVERY TERM (ID) |
| PURCHASE ORDER LINE (DIM_PO_DATE_ENTERED_ID) - CREATED DATE (ID) |
| PURCHASE ORDER LINE (DIM_POL_WANTED_DEL_DATE_ID) - WANTED DELIVERY DATE (ID) |
| PURCHASE ORDER LINE (DIM_PROJECT_ID) - PROJECT (ID) |
| PURCHASE ORDER LINE (DIM_PURCHASE_BUYER_ID) - PURCHASE BUYER (ID) |
| PURCHASE ORDER LINE (DIM_PURCHASE_GROUP_ID) - PURCHASE GROUP (ID) |
| PURCHASE ORDER LINE (DIM_PURCHASE_PART_ID) - PURCHASE PART (ID) |
| PURCHASE ORDER LINE (DIM_QUALITY_CTRL_ANALYST_ID) - QUALITY CONTROL ANALYST (ID) |
| PURCHASE ORDER LINE (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |
| PURCHASE ORDER LINE (DIM_REPORTING_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| PURCHASE ORDER LINE (DIM_REQUISITIONER_ID) - REQUISITIONER (ID) |
| PURCHASE ORDER LINE (DIM_SITE_ID) - SITE (ID) |
| PURCHASE ORDER LINE (DIM_SUB_PROJECT_ID) - SUB PROJECT (ID) |
| PURCHASE ORDER LINE (DIM_SUPPLIER_ID) - SUPPLIER (ID) |
| PURCHASE ORDER LINE (DIM_SUPPLIER_STAT_GROUP_ID) - SUPPLIER STAT GROUP (ID) |
| PURCHASE ORDER LINE (DIM_TECHNICAL_COORDINATOR_ID) - TECHNICAL COORDINATOR (ID) |
| SPEND ANALYSIS (DIM_ACCOUNT_ID) - ACCOUNT (ID) |
| SPEND ANALYSIS (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| SPEND ANALYSIS (DIM_CATEGORY_ASSORTMENT_ID) - CAT ASSORTMENT (ID) |
| SPEND ANALYSIS (DIM_CATEGORY_ASSORTMNT_NODE_ID) - CAT ASSORTMENT NODE (ID) |
| SPEND ANALYSIS (DIM_CHARGE_TYPE_ID) - PURCHASE CHARGE TYPE (ID) |
| SPEND ANALYSIS (DIM_CODE_B_ID) - CODE B (ID) |
| SPEND ANALYSIS (DIM_CODE_C_ID) - CODE C (ID) |
| SPEND ANALYSIS (DIM_CODE_D_ID) - CODE D (ID) |
| SPEND ANALYSIS (DIM_CODE_E_ID) - CODE E (ID) |
| SPEND ANALYSIS (DIM_CODE_F_ID) - CODE F (ID) |
| SPEND ANALYSIS (DIM_CODE_G_ID) - CODE G (ID) |
| SPEND ANALYSIS (DIM_CODE_H_ID) - CODE H (ID) |
| SPEND ANALYSIS (DIM_CODE_I_ID) - CODE I (ID) |
| SPEND ANALYSIS (DIM_CODE_J_ID) - CODE J (ID) |
| SPEND ANALYSIS (DIM_COMPANY_ID) - COMPANY (ID) |
| SPEND ANALYSIS (DIM_EXTERNAL_SERVICE_TYPE_ID) - EXTERNAL SERVICE TYPE (ID) |
| SPEND ANALYSIS (DIM_MAIN_REPRESENTATIVE_ID) - SALES REPRESENTATIVE (ID) |
| SPEND ANALYSIS (DIM_PROJECT_ID) - PROJECT (ID) |
| SPEND ANALYSIS (DIM_PURCHASE_BUYER_ID) - PURCHASE BUYER (ID) |
| SPEND ANALYSIS (DIM_PURCHASE_GROUP_ID) - PURCHASE GROUP (ID) |
| SPEND ANALYSIS (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |
| SPEND ANALYSIS (DIM_RPD_COMPANY_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| SPEND ANALYSIS (DIM_SITE_ID) - SITE (ID) |
| SPEND ANALYSIS (DIM_SUPPLIER_ASSORTMENT_ID) - SUPPLIER ASSORTMENT (ID) |
| SPEND ANALYSIS (DIM_SUPPLIER_ID) - SUPPLIER (ID) |